<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="Managing Databases">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="gaussdbT_00056.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="30-OceanProtect Appliance 1.5.0-1.6.0 Help Center">
<meta name="DC.Publisher" content="20241029">
<meta name="prodname" content="csbs">
<meta name="documenttype" content="usermanual">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="gaussdbT_00058">
<meta name="DC.Language" content="en-us">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>Managing Databases</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="gaussdbT_00058"></a><a name="gaussdbT_00058"></a>

<h1 class="topictitle1">Managing Databases</h1>
<div><p>The <span id="gaussdbT_00058__en-us_topic_0000001792344090_text371620488123">OceanProtect</span> allows you to perform operations on databases, such as modifying, removing, activating, and disabling protection.</p>
<div class="section"><h4 class="sectiontitle">Related Operations</h4><p>You need to log in to the OceanProtect WebUI, choose <span class="uicontrol"><b><span id="gaussdbT_00058__en-us_topic_0000001839142377_text164093351368"><strong>Protection</strong></span> &gt; Databases &gt; GaussDB T</b></span>, and find the target database.</p>
</div>
<div class="p"><a href="#gaussdbT_00058__en-us_topic_0000001263776850_table24934294919">Table 1</a> describes the related operations.
<div class="tablenoborder"><a name="gaussdbT_00058__en-us_topic_0000001263776850_table24934294919"></a><a name="en-us_topic_0000001263776850_table24934294919"></a><table cellpadding="4" cellspacing="0" summary="" id="gaussdbT_00058__en-us_topic_0000001263776850_table24934294919" frame="border" border="1" rules="all"><caption><b>Table 1 </b>Database protection operations</caption><colgroup><col style="width:14.37%"><col style="width:57.9%"><col style="width:27.73%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="14.370000000000003%" id="mcps1.3.3.2.2.4.1.1"><p>Operation</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="57.900000000000006%" id="mcps1.3.3.2.2.4.1.2"><p>Description</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="27.730000000000004%" id="mcps1.3.3.2.2.4.1.3"><p>Navigation Path</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="14.370000000000003%" headers="mcps1.3.3.2.2.4.1.1 "><p>Modifying protection</p>
</td>
<td class="cellrowborder" valign="top" width="57.900000000000006%" headers="mcps1.3.3.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to modify the protection plan to reselect an SLA associated with a database. After the modification, the next backup will be executed based on the new protection plan.</p>
<p><strong>Note</strong></p>
<ul><li id="gaussdbT_00058__en-us_topic_0000001792344090_li16343131892419">The modification does not affect the protection job that is being executed. The modified protection plan will apply to the next protection period.</li><li id="gaussdbT_00058__en-us_topic_0000001792344090_li140522162517">If the protection policy for a resource in the associated SLA changes, you are advised to modify the current SLA on the <span class="uicontrol" id="gaussdbT_00058__en-us_topic_0000001792344090_uicontrol10405524254"><b><span id="gaussdbT_00058__en-us_topic_0000001792344090_text6405425255"><strong>Protection</strong></span> &gt; <span id="gaussdbT_00058__en-us_topic_0000001792344090_text885333645815"><strong>Protection Policies</strong></span> &gt; <span id="gaussdbT_00058__en-us_topic_0000001792344090_text164051025259"><strong>SLAs</strong></span></b></span> page, rather than associate the resource with another SLA through protection modification.<p id="gaussdbT_00058__en-us_topic_0000001792344090_p34052272519">After you associate the resource with another SLA by modifying protection, if the copy of the original SLA still exists, the license capacity may be deducted repeatedly.</p>
</li></ul>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.3.2.2.4.1.3 "><p>In the row of the target database, choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Modify Protection</strong></span></b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.370000000000003%" headers="mcps1.3.3.2.2.4.1.1 "><p>Removing protection</p>
</td>
<td class="cellrowborder" valign="top" width="57.900000000000006%" headers="mcps1.3.3.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to remove the protection plan if a database no longer needs to be protected. After the removal, the system cannot execute protection jobs for the database. To protect the database again, you need to associate an SLA with it again.</p>
<p><strong>Note</strong></p>
<ul><li>When the protection job of the database is running, protection cannot be removed.</li><li>If the protection policy for a resource in the associated SLA changes, you are advised to modify the associated SLA on the <span class="uicontrol" id="gaussdbT_00058__en-us_topic_0000001792344090_uicontrol5174547101015"><b><span id="gaussdbT_00058__en-us_topic_0000001792344090_en-us_topic_0000001839142377_text71111921162814"><strong>Protection</strong></span> &gt; Protection Policies &gt; SLAs</b></span> page, rather than perform SLA re-association after protection removal.<p id="gaussdbT_00058__en-us_topic_0000001792344090_p636319506192">After you remove protection and perform SLA re-association, if the copy of the original SLA still exists, the license capacity may be deducted repeatedly.</p>
</li></ul>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.3.2.2.4.1.3 "><p>In the row of the target database, choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Remove Protection</strong></span></b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.370000000000003%" headers="mcps1.3.3.2.2.4.1.1 "><p>Manual backup</p>
</td>
<td class="cellrowborder" valign="top" width="57.900000000000006%" headers="mcps1.3.3.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to perform a backup immediately.</p>
<p><strong>Note</strong></p>
<p>Copies generated by manual backup are retained for the duration defined in the SLA.</p>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.3.2.2.4.1.3 "><p>In the row of the target database, choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Manual Backup</strong></span></b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.370000000000003%" headers="mcps1.3.3.2.2.4.1.1 "><p>Disabling protection</p>
</td>
<td class="cellrowborder" valign="top" width="57.900000000000006%" headers="mcps1.3.3.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to disable the protection plan of a database for which periodic protection is not required. After the protection plan is disabled, the system does not execute automatic backup jobs for the database.</p>
<p><strong>Note</strong></p>
<p>Disabling protection does not affect ongoing backup jobs.</p>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.3.2.2.4.1.3 "><p>In the row of the target database, choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Disable Protection</strong></span></b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.370000000000003%" headers="mcps1.3.3.2.2.4.1.1 "><p>Activating protection</p>
</td>
<td class="cellrowborder" valign="top" width="57.900000000000006%" headers="mcps1.3.3.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to activate a disabled protection plan of a database. After the protection plan is activated, the system backs up the database based on the protection plan.</p>
<p><strong>Note</strong></p>
<p>This operation can be performed only for a database that has been associated with an SLA and is in <span class="uicontrol"><b><span><strong>Unprotected</strong></span></b></span> state.</p>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.3.2.2.4.1.3 "><p>In the row of the target database, choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Activate Protection</strong></span></b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.370000000000003%" headers="mcps1.3.3.2.2.4.1.1 "><p>Deleting a database</p>
</td>
<td class="cellrowborder" valign="top" width="57.900000000000006%" headers="mcps1.3.3.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to delete a database when it no longer needs to be protected or is used as the restoration target.</p>
<p><strong>Note</strong></p>
<p>If a database has been associated with an SLA, the database cannot be deleted. You need to remove the database protection before deleting the database.</p>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.3.2.2.4.1.3 "><p>In the row of the target database, choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Delete</strong></span></b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.370000000000003%" headers="mcps1.3.3.2.2.4.1.1 "><p>Testing connectivity</p>
</td>
<td class="cellrowborder" valign="top" width="57.900000000000006%" headers="mcps1.3.3.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to perform manual connectivity test of the registered database to check the connectivity between the database and the agent host and between the database and the production environment.</p>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.3.2.2.4.1.3 "><p>In the row of the target database, choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Test Connectivity</strong></span></b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.370000000000003%" headers="mcps1.3.3.2.2.4.1.1 "><p>Modifying database information</p>
</td>
<td class="cellrowborder" valign="top" width="57.900000000000006%" headers="mcps1.3.3.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to modify the name, username, deployment mode, and node of a database.</p>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.3.2.2.4.1.3 "><p>In the row of the target database, choose <span class="uicontrol"><b><span><strong>More</strong></span> &gt; <span><strong>Modify</strong></span></b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.370000000000003%" headers="mcps1.3.3.2.2.4.1.1 "><div class="p">Authorizing resources<div class="note" id="gaussdbT_00058__en-us_topic_0000001839223137_note1819152144411"><span class="notetitle"> NOTE: </span><div class="notebody"><p id="gaussdbT_00058__en-us_topic_0000001839223137_p72172194413">Only version 1.5.0 supports this function.</p>
</div></div>
</div>
</td>
<td class="cellrowborder" valign="top" width="57.900000000000006%" headers="mcps1.3.3.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>By default, only the system administrator has the permission to protect resources. If you want to assign this permission to a data protection administrator, authorize the data protection administrator as the system administrator to protect resources.</p>
<p><strong>Note</strong></p>
<ul><li id="gaussdbT_00058__en-us_topic_0000001839223137_li1491782615119">The protection permissions on a resource that has been associated with an SLA cannot be granted. Before permission granting, remove the protection.</li><li id="gaussdbT_00058__en-us_topic_0000001839223137_li14274329155112">The protection permissions on a single resource can be granted only to a single data protection administrator.</li></ul>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.3.2.2.4.1.3 "><p>In the row of the target resource, choose <span class="uicontrol" id="gaussdbT_00058__en-us_topic_0000001839223137_uicontrol9137201042215"><b><span id="gaussdbT_00058__en-us_topic_0000001839223137_text15137171062219"><strong>More</strong></span> &gt; <span id="gaussdbT_00058__en-us_topic_0000001839223137_text12137010162219"><strong>Authorize Resource</strong></span></b></span>. Then, select the desired data protection administrator.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.370000000000003%" headers="mcps1.3.3.2.2.4.1.1 "><div class="p">Reclaiming resources<div class="note" id="gaussdbT_00058__en-us_topic_0000001839223137_note9135337194416"><span class="notetitle"> NOTE: </span><div class="notebody"><p id="gaussdbT_00058__en-us_topic_0000001839223137_en-us_topic_0000001839223137_p72172194413">Only version 1.5.0 supports this function.</p>
</div></div>
</div>
</td>
<td class="cellrowborder" valign="top" width="57.900000000000006%" headers="mcps1.3.3.2.2.4.1.2 "><p><strong>Scenario</strong></p>
<p>This operation enables you to reclaim resources authorized to the data protection administrator. The data protection administration is not permitted to protect the resources that have been reclaimed.</p>
<p><strong>Note</strong></p>
<p>The protection permissions on a resource that has been associated with an SLA cannot be reclaimed. Before reclamation, remove the protection.</p>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.3.2.2.4.1.3 "><p>In the row of the target resource, choose <span class="uicontrol" id="gaussdbT_00058__en-us_topic_0000001839223137_uicontrol37971414213"><b><span id="gaussdbT_00058__en-us_topic_0000001839223137_text92931039714"><strong>More</strong></span> &gt; <span id="gaussdbT_00058__en-us_topic_0000001839223137_text118771624064"><strong>Reclaim Resource</strong></span></b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.370000000000003%" headers="mcps1.3.3.2.2.4.1.1 "><div class="p">Adding a tag<div class="note" id="gaussdbT_00058__en-us_topic_0000001792344090_note161679211561"><span class="notetitle"> NOTE: </span><div class="notebody"><p id="gaussdbT_00058__en-us_topic_0000001792344090_p1816719214566">Only 1.6.0 and later versions support this function.</p>
</div></div>
</div>
</td>
<td class="cellrowborder" valign="top" width="57.900000000000006%" headers="mcps1.3.3.2.2.4.1.2 "><p><strong id="gaussdbT_00058__en-us_topic_0000001792344090_b1495945913127">Scenario</strong></p>
<p>This operation enables you to quickly filter and manage resources.</p>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.3.2.2.4.1.3 "><div class="p">Choose <span class="uicontrol" id="gaussdbT_00058__en-us_topic_0000001792344090_uicontrol84421111904"><b><span id="gaussdbT_00058__en-us_topic_0000001792344090_text6442710012"><strong>More</strong></span> &gt; Add Tag</b></span>.<div class="note" id="gaussdbT_00058__en-us_topic_0000001792344090_note164681316118"><span class="notetitle"> NOTE: </span><div class="notebody"><ul id="gaussdbT_00058__en-us_topic_0000001792344090_ul22969251338"><li id="gaussdbT_00058__en-us_topic_0000001792344090_li142961925139">On the displayed <strong id="gaussdbT_00058__en-us_topic_0000001792344090_b171967427617">Add Tag</strong> dialog box, you can select existing tags or click <strong id="gaussdbT_00058__en-us_topic_0000001792344090_b1711194810818">Create</strong> to create a tag.</li><li id="gaussdbT_00058__en-us_topic_0000001792344090_li135161927738">To modify or delete a tag, click <strong id="gaussdbT_00058__en-us_topic_0000001792344090_b17675195912164">Go to Tag Management</strong> on the <strong id="gaussdbT_00058__en-us_topic_0000001792344090_b13536183171711">Add Tag</strong> page to go to the <strong id="gaussdbT_00058__en-us_topic_0000001792344090_b1386161351713">Tag Management</strong> page.</li></ul>
</div></div>
</div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="14.370000000000003%" headers="mcps1.3.3.2.2.4.1.1 "><div class="p">Removing a tag<div class="note" id="gaussdbT_00058__en-us_topic_0000001792344090_note4957114117575"><span class="notetitle"> NOTE: </span><div class="notebody"><p id="gaussdbT_00058__en-us_topic_0000001792344090_en-us_topic_0000001792344090_p1816719214566">Only 1.6.0 and later versions support this function.</p>
</div></div>
</div>
</td>
<td class="cellrowborder" valign="top" width="57.900000000000006%" headers="mcps1.3.3.2.2.4.1.2 "><p><strong id="gaussdbT_00058__en-us_topic_0000001792344090_b472911291311">Scenario</strong></p>
<p>This operation enables you to remove the tag of a resource when it is no longer needed.</p>
</td>
<td class="cellrowborder" valign="top" width="27.730000000000004%" headers="mcps1.3.3.2.2.4.1.3 "><p>Choose <span class="uicontrol" id="gaussdbT_00058__en-us_topic_0000001792344090_uicontrol4993205113111"><b><span id="gaussdbT_00058__en-us_topic_0000001792344090_text6993751201118"><strong>More</strong></span> &gt; Remove Tag</b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" colspan="3" valign="top" headers="mcps1.3.3.2.2.4.1.1 mcps1.3.3.2.2.4.1.2 mcps1.3.3.2.2.4.1.3 "><p>Note: The configuration for restoring a database is similar to that in <a href="gaussdbT_00045.html">Restoring the GaussDB T Database</a> and is not described in this section.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="gaussdbT_00056.html">GaussDB T Database Environment</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">Copyright &copy; Huawei Technologies Co., Ltd.</div></body>
</html>